INSERT INTO t_ass_menu_grafico(id, id_menu, id_grafico, id_user, id_group) VALUES (1,2,1,2,null);
INSERT INTO t_ass_menu_grafico(id, id_menu, id_grafico, id_user, id_group) VALUES (2,3,2,2,null);
INSERT INTO t_ass_menu_grafico(id, id_menu, id_grafico, id_user, id_group) VALUES (3,4,3,2,null);

INSERT INTO t_ass_menu_mappa(id, id_menu, id_mappa, id_user, id_group) VALUES (1,2,1,2,null);
INSERT INTO t_ass_menu_mappa(id, id_menu, id_mappa, id_user, id_group) VALUES (2,3,2,2,null);
INSERT INTO t_ass_menu_mappa(id, id_menu, id_mappa, id_user, id_group) VALUES (3,4,4,2,null);

INSERT INTO t_ass_menu_user(id, id_menu, id_user, selected, active) VALUES (1,1,2,FALSE,TRUE);
INSERT INTO t_ass_menu_user(id, id_menu, id_user, selected, active) VALUES (2,2,2,TRUE,TRUE);
INSERT INTO t_ass_menu_user(id, id_menu, id_user, selected, active) VALUES (3,3,2,FALSE,TRUE);
INSERT INTO t_ass_menu_user(id, id_menu, id_user, selected, active) VALUES (4,4,2,FALSE,TRUE);

INSERT INTO t_grafico(id_grafico, nome, tipo, class_name, stacked, legend, labels, series) VALUES (1,'Grafico 1','bar','chart-bar',FALSE,TRUE,'IeFP,Lavoro e competenze,Rete politecnica','Maschi');
INSERT INTO t_grafico(id_grafico, nome, tipo, class_name, stacked, legend, labels, series) VALUES (2,'Grafico 2','bar','chart-bar',FALSE,FALSE,'TestA,TestB,TestC','Femmine');
INSERT INTO t_grafico(id_grafico, nome, tipo, class_name, stacked, legend, labels, series) VALUES (3,'Grafico 3','bar','chart-bar',FALSE,FALSE,'Test1,Test2,Test3','MaschiFemmine');

INSERT INTO t_left_menu(id, id_parent, nome, value, open, selected, active, class_name, include, short_name, 'order')
VALUES ('10','','Obiettivi Tematici','',,FALSE,TRUE,'','','',2);
INSERT INTO t_left_menu(id, id_parent, nome, value, open, selected, active, class_name, include, short_name, 'order')
VALUES ('11','10','Ricerca e innovazione','ricerca-e-innovazione',,FALSE,TRUE,'','','',1);
INSERT INTO t_left_menu(id, id_parent, nome, value, open, selected, active, class_name, include, short_name, 'order')
VALUES ('12','10','Tecnologie dell''informazione e della comunicazione','tecnologie-informazione-comunicazione',,FALSE,TRUE,'','','',2);
INSERT INTO t_left_menu(id, id_parent, nome, value, open, selected, active, class_name, include, short_name, 'order')
VALUES ('13','10','Competitività del sistema produttivo','competitivita-sistema',,FALSE,TRUE,'','','',3);
INSERT INTO t_left_menu(id, id_parent, nome, value, open, selected, active, class_name, include, short_name, 'order')
VALUES ('14','10','Low carbon economy','low-carbon',,FALSE,TRUE,'','','',4);
INSERT INTO t_left_menu(id, id_parent, nome, value, open, selected, active, class_name, include, short_name, 'order')
VALUES ('20','','Strategie integrate','',,FALSE,TRUE,'','','',3);
INSERT INTO t_left_menu(id, id_parent, nome, value, open, selected, active, class_name, include, short_name, 'order')
VALUES ('21','20','Smart Specialization Strategy (S3)','smart-specialization-strategy-S3',,FALSE,TRUE,'','','',1);
INSERT INTO t_left_menu(id, id_parent, nome, value, open, selected, active, class_name, include, short_name, 'order')
VALUES ('22','20','Patto per il lavoro','patto-per-il-lavoro',,FALSE,TRUE,'','','',2);
INSERT INTO t_left_menu(id, id_parent, nome, value, open, selected, active, class_name, include, short_name, 'order')
VALUES ('23','20','Strategia nazionale per le aree interne','strategia-nazionale-per-le-aree-interne',,FALSE,TRUE,'','','',3);
INSERT INTO t_left_menu(id, id_parent, nome, value, open, selected, active, class_name, include, short_name, 'order')
VALUES ('24','20','Green Economy','green-economy',,FALSE,TRUE,'','','',4);
INSERT INTO t_left_menu(id, id_parent, nome, value, open, selected, active, class_name, include, short_name, 'order')
VALUES ('30','','Attività economica dei singoli progetti','',,FALSE,TRUE,'','','',4);
INSERT INTO t_left_menu(id, id_parent, nome, value, open, selected, active, class_name, include, short_name, 'order')
VALUES ('31','30','Smart Specialization Strategy (S3)','smart-specialization-strategy-S3-2',,FALSE,TRUE,'','','',1);
INSERT INTO t_left_menu(id, id_parent, nome, value, open, selected, active, class_name, include, short_name, 'order')
VALUES ('32','30','Patto per il lavoro','patto-per-il-lavoro-2',,FALSE,TRUE,'','','',2);
INSERT INTO t_left_menu(id, id_parent, nome, value, open, selected, active, class_name, include, short_name, 'order')
VALUES ('33','30','Strategia nazionale per le aree interne','strategia-nazionale-per-le-aree-interne-2',,FALSE,TRUE,'','','',3);
INSERT INTO t_left_menu(id, id_parent, nome, value, open, selected, active, class_name, include, short_name, 'order')
VALUES ('34','30','Green Economy','green-economy-2',,FALSE,TRUE,'','','',4);
INSERT INTO t_left_menu(id, id_parent, nome, value, open, selected, active, class_name, include, short_name, 'order')
VALUES ('40','','Territorio','',,FALSE,FALSE,'','','',5);
INSERT INTO t_left_menu(id, id_parent, nome, value, open, selected, active, class_name, include, short_name, 'order')
VALUES ('41','40','Smart Specialization Strategy (S3)','smart-specialization-strategy-S3-3',,FALSE,FALSE,'','','',1);
INSERT INTO t_left_menu(id, id_parent, nome, value, open, selected, active, class_name, include, short_name, 'order')
VALUES ('42','40','Patto per il lavoro','patto-per-il-lavoro-3',,FALSE,FALSE,'','','',2);
INSERT INTO t_left_menu(id, id_parent, nome, value, open, selected, active, class_name, include, short_name, 'order')
VALUES ('43','40','Strategia nazionale per le aree interne','strategia-nazionale-per-le-aree-interne-3',,FALSE,FALSE,'','','',3);
INSERT INTO t_left_menu(id, id_parent, nome, value, open, selected, active, class_name, include, short_name, 'order')
VALUES ('44','40','Green Economy','green-economy-3',,FALSE,FALSE,'','','',4);
INSERT INTO t_left_menu(id, id_parent, nome, value, open, selected, active, class_name, include, short_name, 'order')
VALUES ('50','','Persone','',,FALSE,FALSE,'','','',6);
INSERT INTO t_left_menu(id, id_parent, nome, value, open, selected, active, class_name, include, short_name, 'order')
VALUES ('51','50','Smart Specialization Strategy (S3)','smart-specialization-strategy-S3-4',,FALSE,FALSE,'','','',1);
INSERT INTO t_left_menu(id, id_parent, nome, value, open, selected, active, class_name, include, short_name, 'order')
VALUES ('52','50','Patto per il lavoro','patto-per-il-lavoro-4',,FALSE,FALSE,'','','',2);
INSERT INTO t_left_menu(id, id_parent, nome, value, open, selected, active, class_name, include, short_name, 'order')
VALUES ('53','50','Strategia nazionale per le aree interne','strategia-nazionale-per-le-aree-interne-4',,FALSE,FALSE,'','','',3);
INSERT INTO t_left_menu(id, id_parent, nome, value, open, selected, active, class_name, include, short_name, 'order')
VALUES ('54','50','Green Economy','green-economy-4',,FALSE,FALSE,'','','',4);
INSERT INTO t_left_menu(id, id_parent, nome, value, open, selected, active, class_name, include, short_name, 'order')
VALUES ('fesr','Fondo','Fondo europeo di sviluppo regionale','fondo-europeo',,FALSE,TRUE,'fesr','page/fesr.jsp','FESR',2);
INSERT INTO t_left_menu(id, id_parent, nome, value, open, selected, active, class_name, include, short_name, 'order')
VALUES ('Fondo','','Fondo','',TRUE,FALSE,TRUE,'fondi','','',1);
INSERT INTO t_left_menu(id, id_parent, nome, value, open, selected, active, class_name, include, short_name, 'order')
VALUES ('fse','Fondo','Fondo Sociale Europeo','fondo-sociale-europeo',,TRUE,TRUE,'fse','page/fse.jsp','FSE',1);
INSERT INTO t_left_menu(id, id_parent, nome, value, open, selected, active, class_name, include, short_name, 'order')
VALUES ('psr','Fondo','Programma di sviluppo rurale','programma-sviluppo-rurale',,FALSE,TRUE,'psr','page/psr.jsp','PSR',3);

INSERT INTO t_mappa(id_mappa, campo, num_classi, da_colore, a_colore, tipo_mappa, url_json_dati, campo_label, url_json_dati_point)
VALUES (1,'importoConcesso',3,'#ffffff','#00ff00','Eq','json/no-cluster/eurGeoJson.json','Importo Conceso','');
INSERT INTO t_mappa(id_mappa, campo, num_classi, da_colore, a_colore, tipo_mappa, url_json_dati, campo_label, url_json_dati_point)
VALUES (2,'importoConcesso',4,'#ffffff','#ff0000','Qu','json/no-cluster/eurGeoJson.json','Importo Concesso','');
INSERT INTO t_mappa(id_mappa, campo, num_classi, da_colore, a_colore, tipo_mappa, url_json_dati, campo_label, url_json_dati_point)
VALUES (3,'importoPagato',5,'#ffffff','#000000','Ch','json/no-cluster/eurGeoJson.json','Importo Pagato','');
INSERT INTO t_mappa(id_mappa, campo, num_classi, da_colore, a_colore, tipo_mappa, url_json_dati, campo_label, url_json_dati_point)
VALUES (4,'importoPagato',0,'#0000ff','','Cl','json/cluster/PolGeoJson.json','Importo Pagato','json/cluster/PoiGeoJson.json');

INSERT INTO t_mappa_range(id_range, id_mappa, da_valore, a_valore, numero_range)
VALUES (1,3,1,100,1);
INSERT INTO t_mappa_range(id_range, id_mappa, da_valore, a_valore, numero_range)
VALUES (2,3,100,1000,2);
INSERT INTO t_mappa_range(id_range, id_mappa, da_valore, a_valore, numero_range)
VALUES (3,3,1000,10000,3);
INSERT INTO t_mappa_range(id_range, id_mappa, da_valore, a_valore, numero_range)
VALUES (4,3,10000,100000,4);
INSERT INTO t_mappa_range(id_range, id_mappa, da_valore, a_valore, numero_range)
VALUES (5,3,100000,1000000,5);

INSERT INTO t_menu(id, id_parent, nome, value, open, class_name, short_name, order_menu)
VALUES (1,,'Fondo','',TRUE,'fondi','',1);
INSERT INTO t_menu(id, id_parent, nome, value, open, class_name, short_name, order_menu)
VALUES (2,1,'Fondo Sociale Europeo','fondo-sociale-europeo',,'fse','FSE',1);
INSERT INTO t_menu(id, id_parent, nome, value, open, class_name, short_name, order_menu)
VALUES (3,1,'Fondo europeo di sviluppo regionale','fondo-europeo',,'fesr','FESR',2);
INSERT INTO t_menu(id, id_parent, nome, value, open, class_name, short_name, order_menu)
VALUES (4,1,'Programma di sviluppo rurale','programma-sviluppo-rurale',,'psr','PSR',3);

INSERT INTO t_menu_preferiti(id, id_parent, id_user, id_menu, nome)
VALUES (32454550,null,2,null,'Preferito');
INSERT INTO t_menu_preferiti(id, id_parent, id_user, id_menu, nome)
VALUES (32454551,32454550,2,2,'Preferito-32454550');
INSERT INTO t_menu_preferiti(id, id_parent, id_user, id_menu, nome)
VALUES (32454552,32454550,2,3,'Preferito-32454550');
INSERT INTO t_menu_preferiti(id, id_parent, id_user, id_menu, nome)
VALUES (32454553,32454550,2,4,'Preferito-32454550');

INSERT INTO t_preferiti_left_menu(id, id_parent, id_user, id_left_menu, nome)
VALUES (32454433,,1,'','Preferito');
INSERT INTO t_preferiti_left_menu(id, id_parent, id_user, id_left_menu, nome)
VALUES (32454434,32454433,1,'fse','Preferito-32454433');
INSERT INTO t_preferiti_left_menu(id, id_parent, id_user, id_left_menu, nome)
VALUES (32454435,32454433,1,'fesr','Preferito-32454433');
INSERT INTO t_preferiti_left_menu(id, id_parent, id_user, id_left_menu, nome)
VALUES (32454436,,1,'','Preferito');
INSERT INTO t_preferiti_left_menu(id, id_parent, id_user, id_left_menu, nome)
VALUES (32454437,32454436,1,'fesr','Preferito-32454436');
INSERT INTO t_preferiti_left_menu(id, id_parent, id_user, id_left_menu, nome)
VALUES (32454438,32454436,1,'psr','Preferito-32454436');
INSERT INTO t_preferiti_left_menu(id, id_parent, id_user, id_left_menu, nome)
VALUES (32454439,,1,'','Preferito');
INSERT INTO t_preferiti_left_menu(id, id_parent, id_user, id_left_menu, nome)
VALUES (32454440,32454439,1,'fse','Preferito-32454439');

INSERT INTO t_user(id, nome, cognome, username) VALUES (1,'Massimo','Rossi','massimorossi'),


